var express=require('express');
var app =express();
var mysql = require('mysql');
//链接数据库
var connection = mysql.createConnection({
    host: '127.0.0.1',
    user: 'root',
    password : '123456',
    database : 'ldkj'
});
connection.connect();
//设置跨域访问
app.all('*', function(req, res, next) {
    res.header("Access-Control-Allow-Origin", "*");
    res.header("Access-Control-Allow-Headers", "X-Requested-With");
    res.header("Access-Control-Allow-Methods","PUT,POST,GET,DELETE,OPTIONS");
    res.header("X-Powered-By",' 3.2.1');
    res.header("Content-Type", "application/json;charset=utf-8");
    next();
});

var result = {
    "status": "200",
    "message": "success",
}
connection.query('select * from websites', function(err, rows, fields) {
    if (err) throw err;
    return  result.data=rows;
});

//写个接口信息                                                           /123
app.get('/123',function(req,res){
    res.status(200),
        res.json(result)
});

var resultimg = {
    "status" : "200",
    "message" : "success",
}
connection.query('select * from rotation', function (err, rows, fields){
    if (err) throw err;
    return resultimg.data = rows;
})
//  主页轮播图接口                                                       index/rotation
app.get('/index/rotation',function ( req,res ){
    res.status(200),
        res.json(resultimg)
})

var resultuser = {
    "status" : "200",
    "message" : "success",
}
connection.query('select * from admin', function (err, rows, fields){
    if (err) throw err;
    return resultuser.data = rows;
})
//  主页轮播图接口                                                       index/user
app.get('/index/user',function ( req,res ){
    res.status(200),
        res.json(resultuser)
})

connection.end();


//配置服务端口
var server = app.listen(3000, function () {
    var host = server.address().address;
    var port = server.address().port;
    console.log('Example app listening at http://%s:%s', host, port);
})